package com.dormitory_springboot.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dormitory_springboot.bean.Apply;
import com.dormitory_springboot.vo.ResultV1;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @auther 夏杨
 **/
public interface ApplyMapper extends BaseMapper<Apply> {
    @Select("select id,type,infor,date,issolved,name,Dorid,Hmid,phone,email from apply,student where Apply.Sid = Student.Sid and issolved = false and Dorid like #{str};")
    public List<ResultV1> getUsefulApplyBySex(String str);
}
